import numpy as np
import pandas as pd
df = pd.DataFrame({
"quarter": [1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4],
"x": np.random.randn(12),
"date": pd.date_range("2024-01-01", periods=12, freq="MS")
})
df.head()| quarter | x | date | |
|---|---|---|---|
| 0 | 1 | 1.009997 | 2024-01-01 |
| 1 | 1 | 1.451022 | 2024-02-01 |
| 2 | 1 | -0.216127 | 2024-03-01 |
| 3 | 2 | -0.761972 | 2024-04-01 |
| 4 | 2 | -0.409263 | 2024-05-01 |